/*
Navicat MySQL Data Transfer

Source Server         : local
Source Server Version : 50711
Source Host           : localhost:3306
Source Database       : fitment

Target Server Type    : MYSQL
Target Server Version : 50711
File Encoding         : 65001

Date: 2022-03-11 11:04:24
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `activity`
-- ----------------------------
DROP TABLE IF EXISTS `activity`;
CREATE TABLE `activity` (
`id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`intro`  varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
`photo_url`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of activity
-- ----------------------------
BEGIN;
INSERT INTO `activity` VALUES ('36da49ecc3c2403da76be618d940df1e', 'sdfsdf', 'sdfsdfsdfsdfsdf撒旦发射点', '2022-03-08 11:27:34', '\\activity\\13973239095064.png');
COMMIT;

-- ----------------------------
-- Table structure for `article`
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
`id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`type`  int(1) NULL DEFAULT NULL ,
`main_id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`content`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
INDEX `index_mid` (`type`, `main_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` VALUES ('1d39595d87e54c7e9a9d16570c8f7329', '7', '8170cdc7d7e74e6aad31abe505a4030f', '<p><img src=\"\\upload\\editor\\13973239095207.png\" style=\"max-width:100%;\" width=\"348\" height=\"348\" contenteditable=\"false\"/><br/></p>', '2022-03-05 14:42:56'), ('555furniture', '5', '555furniture', '<p>啊啊啊啊啊啊啊啊啊啊啊啊<br/></p>', '2022-03-05 11:14:01'), ('666govern', '6', '666govern', null, null), ('7b18d96e1dd44033a35a291f9f3fd4a2', '1', '3', '<p><img src=\"\\upload\\editor\\14222031387244.jpeg\" style=\"max-width:100%;\" width=\"545\" height=\"340.42\" contenteditable=\"false\"/>星球介绍22222<br/></p>', '2022-03-03 16:05:16'), ('999', '2', '1', '<p>禾诚装饰有限公司是一家集室内外设计、预算、施工、材料于一体的专业化装饰公司。公司从事装饰装修行业多年，有着创新的设计、合理的报价，还有一批独立的专业化的施工队伍，确保施工绿色环保，安全文明。 <br/>公司本着“崇尚自由，追求完美”的设计理念，凭借超前的设计构思、合理的预算报价、精良的施工工艺，优质的全程服务，真诚的为每一位顾客，量身定制全新、优雅、舒适的居家生活、文化空间。 <br/>自公司成立以来，全体员工一直秉承“以质量求生存，以信誉求发展”的经营理念，始终坚持以客户的需求和满意为核心，以“诚信”为宗旨，不断的用优质、精美、具有创造力的空间装饰产品为客户提供更大的价值回报，从而使公司不断发展壮大 。</p>', '2022-03-03 16:34:37'), ('999decoration', '3', '999decoration', '<p><br/><img src=\"\\upload\\editor\\14222031384681.jpeg\" style=\"max-width:100%;\" contenteditable=\"false\"/></p><p><img src=\"\\upload\\editor\\910573640828.jpg\" style=\"max-width:100%;\" contenteditable=\"false\"/>aaaaa<br/></p>', null), ('bead18aa42614545ac2b10c211bce95d', '4', 'fc79971051dc459487ac06bd262ccd73', '<p>手动阀手动阀<br/></p>', '2022-03-08 11:47:10'), ('cf9771ba2b114b14a1a924f37c68d5e8', '7', '8af35d3d1cd64d799e631ea8b22ac30f', '<p>这是主材包1</p><p><img src=\"\\upload\\editor\\8491211714866.png\" style=\"max-width:100%;\" contenteditable=\"false\"/><br/></p>', '2022-03-05 14:40:58'), ('d7eeff3587e54e1b9aa1530273eaeedc', '8', '36da49ecc3c2403da76be618d940df1e', '<p>撒旦发射点士大夫阿道夫士大夫送到送到送到 <br/></p>', '2022-03-08 11:27:42'), ('f3e90910548f4d35b0205addee71ad6d', '1', '4', '<p>顶顶顶顶顶<br/></p>', '2022-03-05 10:30:53'), ('fdf30b310a304a6e8a048cd816133b4a', '9', '9bbddeb9201f44af9f47e5761321f38c', '<p>手动阀手动阀是<br/></p>', '2022-03-09 10:12:11');
COMMIT;

-- ----------------------------
-- Table structure for `banner`
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
`id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`photo_url`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`tips`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
`article_id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of banner
-- ----------------------------
BEGIN;
INSERT INTO `banner` VALUES ('3', '\\banner\\910573641479.jpg', '欢迎使用本系统22', '2022-03-03 10:43:33', '7b18d96e1dd44033a35a291f9f3fd4a2'), ('4', '\\banner\\14222031381323.jpeg', '第二个', '2022-03-03 10:46:11', 'f3e90910548f4d35b0205addee71ad6d'), ('5', '\\banner\\7767177970028.png', '', '2022-03-03 10:47:20', null);
COMMIT;

-- ----------------------------
-- Table structure for `building_site`
-- ----------------------------
DROP TABLE IF EXISTS `building_site`;
CREATE TABLE `building_site` (
`id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`price`  int(11) NULL DEFAULT NULL ,
`style`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '装修风格' ,
`acreage`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '面积' ,
`house_type`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '户型' ,
`area`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域' ,
`create_time`  datetime NULL DEFAULT NULL ,
`stage`  int(11) NULL DEFAULT 1 ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of building_site
-- ----------------------------
BEGIN;
INSERT INTO `building_site` VALUES ('fc79971051dc459487ac06bd262ccd73', '东华经典', '111', '现代', '100', '三室一厅', '洛江', '2022-03-08 11:46:42', '1');
COMMIT;

-- ----------------------------
-- Table structure for `caseinfo`
-- ----------------------------
DROP TABLE IF EXISTS `caseinfo`;
CREATE TABLE `caseinfo` (
`id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`type`  int(2) NULL DEFAULT NULL ,
`deposit`  int(8) NULL DEFAULT NULL COMMENT '微信付款押金' ,
`end_time`  datetime NULL DEFAULT NULL ,
`common_price1`  int(11) NULL DEFAULT NULL ,
`common_price2`  int(11) NULL DEFAULT NULL ,
`standard_price1`  int(11) NULL DEFAULT NULL ,
`standard_price2`  int(11) NULL DEFAULT NULL ,
`smart_price1`  int(11) NULL DEFAULT NULL ,
`smart_price2`  int(11) NULL DEFAULT NULL ,
`pay_num`  int(11) NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of caseinfo
-- ----------------------------
BEGIN;
INSERT INTO `caseinfo` VALUES ('555furniture', '5', '4000', '2022-03-11 00:00:00', null, null, null, null, null, null, '2', '2022-03-05 11:00:58'), ('666govern', '6', '2000', '2022-03-05 00:00:00', '1500', '2500', '3500', '5800', null, null, '11', '2022-03-05 11:00:54'), ('999decoration', '3', '5000', '2022-03-05 00:00:00', '780', '698', '880', '798', '980', '898', '6', '2022-03-04 11:39:07');
COMMIT;

-- ----------------------------
-- Table structure for `custom`
-- ----------------------------
DROP TABLE IF EXISTS `custom`;
CREATE TABLE `custom` (
`id_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`tel_`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`name_`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`password_`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`create_time_`  datetime NULL DEFAULT NULL ,
`photo_url_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`wechat_id_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`wechat_name_`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ,
`pid`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`type`  int(1) NULL DEFAULT NULL COMMENT '1 普通客户  2 业务员' ,
PRIMARY KEY (`id_`),
UNIQUE INDEX `uk_id` (`id_`) USING BTREE ,
UNIQUE INDEX `UK_5f1` (`tel_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of custom
-- ----------------------------
BEGIN;
INSERT INTO `custom` VALUES ('834ad07d985e4e84965a7989da123e5d', '123456789', 'aaa', null, '2022-03-01 17:46:06', null, '1', null, '2', null), ('b005d84daf444c49b12b862db2c21549', 'test', 'test', '7826099c683f7b0f6f23177b802330b5', '2022-03-01 16:15:50', null, '2', null, null, null);
COMMIT;

-- ----------------------------
-- Table structure for `design_case`
-- ----------------------------
DROP TABLE IF EXISTS `design_case`;
CREATE TABLE `design_case` (
`id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`price`  int(11) NULL DEFAULT NULL ,
`style`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '装修风格' ,
`acreage`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '面积' ,
`house_type`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '户型' ,
`area`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域' ,
`create_time`  datetime NULL DEFAULT NULL ,
`stage`  int(11) NULL DEFAULT 1 ,
`designer_name`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`designer_id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of design_case
-- ----------------------------
BEGIN;
INSERT INTO `design_case` VALUES ('9bbddeb9201f44af9f47e5761321f38c', '三盛四季', '200', '欧式', '120', '三室一厅', '洛江', '2022-03-08 17:05:55', '1', '高级设计师', '0956f522a3714b0e906b35f505c3e7a9');
COMMIT;

-- ----------------------------
-- Table structure for `designer`
-- ----------------------------
DROP TABLE IF EXISTS `designer`;
CREATE TABLE `designer` (
`id`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`star`  int(1) NULL DEFAULT NULL ,
`feedback`  int(3) NULL DEFAULT NULL COMMENT '好评率' ,
`tel`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`deposit`  int(11) NULL DEFAULT NULL COMMENT '押金' ,
`photo_url`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of designer
-- ----------------------------
BEGIN;
INSERT INTO `designer` VALUES ('0956f522a3714b0e906b35f505c3e7a9', '高级设计师', '5', '99', '18974563721', '3000', '\\designer\\7767177974576.png', '2022-03-08 16:07:57'), ('6e18d84e5cc043868d0ea1425a585149', '中级设计师', '1', '92', '17839883761', '2500', '\\designer\\13973239092267.png', '2022-03-08 16:08:24');
COMMIT;

-- ----------------------------
-- Table structure for `goodbad`
-- ----------------------------
DROP TABLE IF EXISTS `goodbad`;
CREATE TABLE `goodbad` (
`id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`intro`  varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
`photo_url`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`type`  int(1) NULL DEFAULT NULL ,
`camp`  int(1) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of goodbad
-- ----------------------------
BEGIN;
INSERT INTO `goodbad` VALUES ('5706cb58008c41088bd4ead8b6262d05', 'sfsdf', 'sdfsdf', '2022-03-08 09:38:33', '\\goodbad\\14222031381996.jpeg', '1', '1'), ('8f1ae21bac364514b9a16d55421c91a8', '12小时在线', '12小时在线', '2022-03-05 17:12:45', '\\goodbad\\13973239098783.png', '4', '2'), ('a729ffe7c9ad4ecf8f9892d6052dcc43', 'aaabbb', 'aaaa', '2022-03-08 10:25:28', '\\goodbad\\13973239092155.png', '1', '2'), ('b77139bd56ef4b38bd632e614cd883a6', '水泥价格', '50一包222222', '2022-03-05 17:11:28', '\\goodbad\\910573645306.jpg', '1', '1'), ('d012012d23294c57b47c2b6b250c6206', '24小时在线', '24小时在线', '2022-03-05 17:12:33', '\\goodbad\\7767177978686.png', '4', '1'), ('dcb6972979d141f7859223dee8afe9e3', '水泥价格', '80一包33333', '2022-03-05 17:12:00', '\\goodbad\\910573642048.jpg', '1', '2');
COMMIT;

-- ----------------------------
-- Table structure for `img`
-- ----------------------------
DROP TABLE IF EXISTS `img`;
CREATE TABLE `img` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`type`  int(2) NULL DEFAULT NULL ,
`main_id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`photo_url`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=30

;

-- ----------------------------
-- Records of img
-- ----------------------------
BEGIN;
INSERT INTO `img` VALUES ('7', '3', '999decoration', '\\decoration\\910573648771.jpg', '2022-03-04 17:20:30'), ('10', '3', '999decoration', '\\decoration\\14222031388881.jpeg', '2022-03-04 17:23:32'), ('11', '3', '999decoration', '\\decoration\\13973239096388.png', '2022-03-04 17:23:32'), ('13', '3', '999decoration', '\\decoration\\8491211718437.png', '2022-03-04 17:29:03'), ('14', '3', '999decoration', '\\decoration\\14222031383146.jpeg', '2022-03-05 10:00:46'), ('21', '6', '666govern', '\\\\910573649366.jpg', '2022-03-05 11:13:30'), ('22', '4', 'fc79971051dc459487ac06bd262ccd73', '\\build\\14222031388681.jpeg', '2022-03-08 11:46:51'), ('23', '4', 'fc79971051dc459487ac06bd262ccd73', '\\build\\13973239096473.png', '2022-03-08 11:46:51'), ('29', '9', '9bbddeb9201f44af9f47e5761321f38c', '\\designercase\\910573640655.jpg', '2022-03-08 17:14:58');
COMMIT;

-- ----------------------------
-- Table structure for `jxc_menu`
-- ----------------------------
DROP TABLE IF EXISTS `jxc_menu`;
CREATE TABLE `jxc_menu` (
`id_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`text_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`icon_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`url_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`pid_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' ,
`flag_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`order_`  int(2) NULL DEFAULT 1 ,
PRIMARY KEY (`id_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of jxc_menu
-- ----------------------------
BEGIN;
INSERT INTO `jxc_menu` VALUES ('1', '系统管理', 'fa fa-home fa-fw', '', '', null, '9'), ('11', '管理员管理', 'fa fa-user  fa-fw', '/go/user', '1', null, '1'), ('12', '角色管理', 'fa fa-leaf  fa-fw', '/go/role', '1', null, '2'), ('13', '菜单管理', 'fa fa-leaf  fa-fw', '/go/menu', '1', null, '3'), ('14', '材料类别', 'fa fa-leaf  fa-fw', '/go/type', '1', null, '4'), ('2', '出入库管理', 'fa fa-leaf  fa-fw', '', '', null, '10'), ('21', '库存汇总', 'fa fa-leaf  fa-fw', '/go/product', '2', null, '3'), ('22', '出库单', 'fa fa-leaf  fa-fw', '/go/productOrderOn/2', '2', null, '1'), ('23', '入库单', 'fa fa-leaf  fa-fw', '/go/productOrderOn/1', '2', null, '2'), ('24', '单据审核', 'fa fa-leaf  fa-fw', '/go/productReview', '2', null, '1'), ('26e9cd1eef00455294b0551f6f0c021c', '设计案例', 'fa fa-pie-chart  fa-fw', '/go/dcase', '42888528be2d471e80a2c30edff317d6', null, '2'), ('42888528be2d471e80a2c30edff317d6', '设计师管理', 'fa fa-users  fa-fw', '', '', null, '3'), ('44fde86d79ec4957845fe82b7899a7ed', '设计师信息', 'fa fa-child  fa-fw', '/go/designer', '42888528be2d471e80a2c30edff317d6', null, '1'), ('49875c7add3c4f17a5bdccf4997077e1', '家居家具', 'fa fa-star  fa-fw', '/go/furniture', 'cea7158e7cc1455bbd1900920552170e', null, '5'), ('51acfaecfa724fc58f42dadb377b629d', '优劣对比', 'fa fa-object-group  fa-fw', '/go/goodbad', 'cea7158e7cc1455bbd1900920552170e', null, '7'), ('5d1e99f6aeae4bc593465ce24cec4390', '押金管理', 'fa fa-cny  fa-fw', '/go/order', '', null, '4'), ('8c9ea61363564ed8ab13fbc9dc7b43c9', 'banner设置', 'fa fa-area-chart  fa-fw', '/go/banner', 'cea7158e7cc1455bbd1900920552170e', null, '1'), ('be8a54a9361d4b94923cf7d2a2bcd1bc', '活动管理', 'fa fa-bell  fa-fw', '/go/activity', '', null, '2'), ('c4ba33e1b1e34b029ecd0dcdb28e8818', '在建工地', 'fa fa-train  fa-fw', '/go/build', 'cea7158e7cc1455bbd1900920552170e', null, '4'), ('cb26381708ab43d78027f44b4de2b431', '主材包', 'fa fa-support  fa-fw', '/go/material', 'cea7158e7cc1455bbd1900920552170e', null, '10'), ('cea7158e7cc1455bbd1900920552170e', '首页功能', 'fa fa-align-justify  fa-fw', '', '', null, '1'), ('e030ffeb421246ae8ff76922b13d11ea', '一键装修', 'fa fa-sitemap  fa-fw', '/go/decoration', 'cea7158e7cc1455bbd1900920552170e', null, '3'), ('ede372f2d96f456bae0a8f4dbb927bd1', '环境治理', 'fa fa-star  fa-fw', '/go/govern', 'cea7158e7cc1455bbd1900920552170e', null, '6'), ('ef110d268c66443cb9b0741ca3c5f15e', '客户管理', 'fa fa-user  fa-fw', '/go/custom', '', null, '1'), ('f2d337bfa37f425db430bb083d1a81d0', '公司简介', 'fa fa-signal  fa-fw', '/go/article/2/1', 'cea7158e7cc1455bbd1900920552170e', null, '2');
COMMIT;

-- ----------------------------
-- Table structure for `jxc_menu_role`
-- ----------------------------
DROP TABLE IF EXISTS `jxc_menu_role`;
CREATE TABLE `jxc_menu_role` (
`id_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`role_id_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`menu_id_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of jxc_menu_role
-- ----------------------------
BEGIN;
INSERT INTO `jxc_menu_role` VALUES ('0a9f896337064163b4b599f007d7b950', '1', 'ef110d268c66443cb9b0741ca3c5f15e'), ('0ea62d8ba3254b45872f37c37991db58', '1', '12'), ('12b4d7069e8743dbb20677212bb1e883', '1', '42888528be2d471e80a2c30edff317d6'), ('15d98d5adc9a4200b919ea229f186194', '31cb2d06a32e4531bbaa7507d61dcbfa', 'cb26381708ab43d78027f44b4de2b431'), ('17a1424f96904f7ab0423ca0d1dcc1f4', '31cb2d06a32e4531bbaa7507d61dcbfa', 'ede372f2d96f456bae0a8f4dbb927bd1'), ('1e45bc8507bf40c4bcfff403a63ee2ab', '1', '13'), ('33163d1f28ba4494af5335bb2f7f1022', '1', 'cea7158e7cc1455bbd1900920552170e'), ('3bec89a326d941e49f22ccd802628990', '31cb2d06a32e4531bbaa7507d61dcbfa', '44fde86d79ec4957845fe82b7899a7ed'), ('479d4241ab0d4a57bc77ac456bcda039', '1', 'ede372f2d96f456bae0a8f4dbb927bd1'), ('63affee7cbbb4df097391f0fd49f8aea', '31cb2d06a32e4531bbaa7507d61dcbfa', '51acfaecfa724fc58f42dadb377b629d'), ('65ea0a7ee3f546ee976e86955d63081d', '1', '44fde86d79ec4957845fe82b7899a7ed'), ('68bb7dbcb3704504a92f44a1e2dfa389', '31cb2d06a32e4531bbaa7507d61dcbfa', '11'), ('6a63b223183b4e85864e1d09b2e04fae', '1', '1'), ('75c80f281adb45a9a9fe3d08643db280', '1', '8c9ea61363564ed8ab13fbc9dc7b43c9'), ('7e8ec83d9d59436eb17cdc7a4b05ce19', '31cb2d06a32e4531bbaa7507d61dcbfa', 'c4ba33e1b1e34b029ecd0dcdb28e8818'), ('7f351ac4ef3c4b23b08ee965e4b0d954', '31cb2d06a32e4531bbaa7507d61dcbfa', '5d1e99f6aeae4bc593465ce24cec4390'), ('84216a0cd59a460aad80c48162de68d4', '1', 'cb26381708ab43d78027f44b4de2b431'), ('9a3d246ae0f6462b8e9b9e236f9203e4', '1', '49875c7add3c4f17a5bdccf4997077e1'), ('9bc8358fe49d42fb8493f4921d2201e2', '31cb2d06a32e4531bbaa7507d61dcbfa', 'be8a54a9361d4b94923cf7d2a2bcd1bc'), ('9da79f7531ca475d9b521e88e6f3f73c', '31cb2d06a32e4531bbaa7507d61dcbfa', 'cea7158e7cc1455bbd1900920552170e'), ('a93aacb7c5a8438cb79b592add6195be', '1', '5d1e99f6aeae4bc593465ce24cec4390'), ('beb438a014514f97876567db9ee697fe', '31cb2d06a32e4531bbaa7507d61dcbfa', '8c9ea61363564ed8ab13fbc9dc7b43c9'), ('c6a7c70d49064b6ab1acbb2e4675235a', '31cb2d06a32e4531bbaa7507d61dcbfa', 'ef110d268c66443cb9b0741ca3c5f15e'), ('cc1697270b80427aa8713f22ddd129ef', '31cb2d06a32e4531bbaa7507d61dcbfa', 'f2d337bfa37f425db430bb083d1a81d0'), ('cfdd71ffd355434eb5b1a14572fd5526', '31cb2d06a32e4531bbaa7507d61dcbfa', '42888528be2d471e80a2c30edff317d6'), ('dff6a70902924f4f94a33e15c50aef4d', '1', 'e030ffeb421246ae8ff76922b13d11ea'), ('e38e46608408428d8d15e9eee965c180', '1', 'c4ba33e1b1e34b029ecd0dcdb28e8818'), ('e682aa1e806641b58d919ced648c277c', '31cb2d06a32e4531bbaa7507d61dcbfa', '1'), ('f25894b33e284534a66b5e30d5a92c13', '1', 'be8a54a9361d4b94923cf7d2a2bcd1bc'), ('f3154d80885d44ef9820522eb61064f3', '1', '51acfaecfa724fc58f42dadb377b629d'), ('f846ca7ee9654e98824b91a05cb47543', '31cb2d06a32e4531bbaa7507d61dcbfa', 'e030ffeb421246ae8ff76922b13d11ea'), ('f851f518bb5c445099d0ff2a219b2e1c', '31cb2d06a32e4531bbaa7507d61dcbfa', '49875c7add3c4f17a5bdccf4997077e1'), ('f8f6a7be1caf4de5983ddc40e055b3aa', '31cb2d06a32e4531bbaa7507d61dcbfa', '26e9cd1eef00455294b0551f6f0c021c'), ('f973572fc59f49b68fa0c8ba3e42f72f', '1', '11'), ('fda5377c0e324e3f8061d5bafbc6d0c5', '1', 'f2d337bfa37f425db430bb083d1a81d0'), ('fdc713a1040c44b6b1d30c465e9d85f5', '1', '26e9cd1eef00455294b0551f6f0c021c');
COMMIT;

-- ----------------------------
-- Table structure for `jxc_product`
-- ----------------------------
DROP TABLE IF EXISTS `jxc_product`;
CREATE TABLE `jxc_product` (
`id_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type_id_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`total_`  int(11) NULL DEFAULT NULL ,
`price_`  int(11) NULL DEFAULT NULL ,
`create_time_`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`id_`),
FOREIGN KEY (`type_id_`) REFERENCES `jxc_type` (`id_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `FK_58bed35f8e3f46a7b886c46b5db` (`type_id_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of jxc_product
-- ----------------------------
BEGIN;
INSERT INTO `jxc_product` VALUES ('1', '2', '78', null, '2018-12-19 14:01:49'), ('2', '4028b8815cd94d1f015cd96626600000', '332', null, '2018-12-18 14:02:20'), ('5a4289fe557741f48d1521c2bd97bb97', '4028b8815cd94d1f015cd96960700006', '1112', null, null);
COMMIT;

-- ----------------------------
-- Table structure for `jxc_product_order`
-- ----------------------------
DROP TABLE IF EXISTS `jxc_product_order`;
CREATE TABLE `jxc_product_order` (
`id_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type_id_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`number_`  int(11) NULL DEFAULT NULL ,
`price_`  int(11) NULL DEFAULT NULL ,
`creater_id_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`creater_`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`order_type_`  int(1) NULL DEFAULT NULL COMMENT '1:入库；2：出库' ,
`create_date_`  datetime NULL DEFAULT NULL ,
`status_`  int(1) NULL DEFAULT NULL COMMENT '订单状态：1、在途；2、驳回、3、结束' ,
`remark_`  varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id_`),
FOREIGN KEY (`type_id_`) REFERENCES `jxc_type` (`id_`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `FK_58bed35f8e3f46a7b886c46b5db` (`type_id_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of jxc_product_order
-- ----------------------------
BEGIN;
INSERT INTO `jxc_product_order` VALUES ('3a9e75fe559d4c6a98d895039cc3bbec', '2', '2', '2', '2', '系统管理员', '2', '2018-12-19 15:03:13', '3', null), ('3ec8dd15445f4d549242ab1117858c87', '4028b8815cd94d1f015cd96960700006', '1', '1', '2', '系统管理员', '1', '2018-12-19 15:01:35', '3', null), ('4b54cfae02c7402a82dc8b28fcd6b94e', '4028b8815cd94d1f015cd96626600000', '22', '2', '1', '黄海水', '2', '2019-06-19 09:56:02', '3', null), ('51041fb495b443a4b27be7faca72aaff', '4028b8815cd94d1f015cd96960700006', '1111', '1', '5', 'hhs', '1', '2018-12-19 16:44:21', '3', null), ('787e2fa4d9104d96b4ff3a69e34aed1a', '4028b8815cd94d1f015cd96626600000', '11', '2', '1', '黄海水', '2', '2018-12-19 16:42:54', '2', '价格太低'), ('98e9e8e5980f4ad9a7b82d1c495145b9', '4028b8815cd94d1f015cd96626600000', '10', '1', '1', '黄海水', '2', '2019-03-05 09:28:24', '3', null), ('a29d916b-d955-4d2f-8b14-a0d15554372d', '2', '1', '1', '1', '黄海水', '2', '2019-10-19 01:53:03', '2', 'fff'), ('a3b2276e28fd49aea4284340e557f1f4', '2', '22', '2', '1', '黄海水', '2', '2018-12-19 16:43:24', '3', null), ('ad834c224e2f46efba71679a1303e48f', '4028b8815cd94d1f015cd96626600000', '11', '1', '1', '黄海水', '2', '2019-01-08 09:20:30', '3', null), ('aea952be89aa42e5be3484b0d69bdef5', '4028b8815cd94d1f015cd96626600000', '123', '1', '1', '黄海水', '2', '2019-03-05 09:27:17', '3', null), ('b63e805dc78e45fd8106ba3b58d0059b', '4028b8815cd94d1f015cd96626600000', '12', '10', '1', '黄海水', '2', '2019-01-08 09:21:49', '1', '单价太低'), ('e4dfd2a4a691453abc71f45029e887a9', '2', '100', '1100', '1', '黄海水', '2', '2018-12-25 09:16:54', '3', 'sddfsdfsdf');
COMMIT;

-- ----------------------------
-- Table structure for `jxc_role`
-- ----------------------------
DROP TABLE IF EXISTS `jxc_role`;
CREATE TABLE `jxc_role` (
`id_`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name_`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`flag_`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id_`),
UNIQUE INDEX `uk_id` (`id_`) USING BTREE ,
UNIQUE INDEX `UK_0e4dd3f5e4c146be8fd988dea68` (`flag_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of jxc_role
-- ----------------------------
BEGIN;
INSERT INTO `jxc_role` VALUES ('1', '超级管理员', 'superadmin'), ('31cb2d06a32e4531bbaa7507d61dcbfa', '管理员', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for `jxc_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `jxc_role_user`;
CREATE TABLE `jxc_role_user` (
`id_`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`user_id_`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`role_id_`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id_`),
INDEX `role` (`role_id_`) USING BTREE ,
INDEX `FK_b9e0450639b8403ea25d5a0275c` (`user_id_`) USING BTREE ,
INDEX `FK_d0ad21af405b491e98770c4187e` (`user_id_`) USING BTREE ,
INDEX `FK_e4e01642a12a46889d99c7b857c` (`role_id_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of jxc_role_user
-- ----------------------------
BEGIN;
INSERT INTO `jxc_role_user` VALUES ('14bc0cc40eb94ec7a7add24fc83493f1', 'b005d84daf444c49b12b862db2c21549', '31cb2d06a32e4531bbaa7507d61dcbfa'), ('3452184b21c94bab9529824edfba4404', 'ebf4f15590294291a31b6d62e17211fe', '31cb2d06a32e4531bbaa7507d61dcbfa'), ('4028b88156cb4b1c0156cb4c3ae90002', '1', '1');
COMMIT;

-- ----------------------------
-- Table structure for `jxc_type`
-- ----------------------------
DROP TABLE IF EXISTS `jxc_type`;
CREATE TABLE `jxc_type` (
`id_`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`pid_`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`name_`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`type_`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`create_time_`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`id_`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of jxc_type
-- ----------------------------
BEGIN;
INSERT INTO `jxc_type` VALUES ('1', '', '服饰', null, null), ('2', '1', '牛仔裤', null, null), ('3', '1', '卫衣', null, null), ('4', null, '食品', null, null), ('4028b8815cd94d1f015cd96626600000', '6', '雪碧', null, null), ('4028b8815cd94d1f015cd96683b70002', '5', '闲趣原味', null, null), ('4028b8815cd94d1f015cd966b1cf0003', '5', '闲趣草莓味', null, null), ('4028b8815cd94d1f015cd96757270004', '3', '优衣库', null, null), ('4028b8815cd94d1f015cd96960700006', '1', '短裤', null, null), ('5', '4', '饼干', null, null), ('6', '4', '饮料', null, null), ('7', '6', '可乐', null, null), ('99caae4e63f2410bb51a37109cb1887a', '', '五金商品', null, '2018-10-19 14:39:11');
COMMIT;

-- ----------------------------
-- Table structure for `material`
-- ----------------------------
DROP TABLE IF EXISTS `material`;
CREATE TABLE `material` (
`id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`intro`  varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
`photo_url`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of material
-- ----------------------------
BEGIN;
INSERT INTO `material` VALUES ('8170cdc7d7e74e6aad31abe505a4030f', '2222', '22222', '2022-03-05 14:41:11', '\\material\\14222031380812.jpeg'), ('8af35d3d1cd64d799e631ea8b22ac30f', 'aaa', 'sfsdfsdfsfd', '2022-03-05 14:35:46', '\\material\\910573647313.jpg');
COMMIT;

-- ----------------------------
-- Table structure for `order_info`
-- ----------------------------
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info` (
`id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`wechat_id`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`custom_id`  varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`wechat_order_id`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`price`  int(11) NULL DEFAULT NULL ,
`intro`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`status`  int(4) NULL DEFAULT NULL COMMENT '状态' ,
`create_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
INDEX `index_cusid` (`custom_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of order_info
-- ----------------------------
BEGIN;
INSERT INTO `order_info` VALUES ('1', '11', '834ad07d985e4e84965a7989da123e5d', '111', '1000', '来自一键装修的押金', '25', '2022-03-09 10:52:40'), ('2', '22', 'b005d84daf444c49b12b862db2c21549', '222', '200', '来自选择设计师的押金', '1', '2022-03-09 10:53:12');
COMMIT;

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id_`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`account_`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`name_`  varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ,
`password_`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`number_`  varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`email_`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`remark_`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`birthday_`  datetime NULL DEFAULT NULL ,
`version_`  int(11) NULL DEFAULT NULL ,
`create_time_`  datetime NULL DEFAULT NULL ,
`photo_url_`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`type_`  int(1) NOT NULL COMMENT '1:超管，2：管理' ,
PRIMARY KEY (`id_`),
UNIQUE INDEX `uk_id` (`id_`) USING BTREE ,
UNIQUE INDEX `UK_5f1` (`account_`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', 'admin', '系统管理员', 'c5e3363cf27f707231c460dc37bb2afe', null, '229386733@qq.com', null, null, '0', null, '\\getPhoto\\photo\\14222031389086.jpeg', '0'), ('b005d84daf444c49b12b862db2c21549', 'test', 'test', '7826099c683f7b0f6f23177b802330b5', null, null, null, '2022-03-01 00:00:00', null, '2022-03-01 16:15:50', null, '2'), ('ebf4f15590294291a31b6d62e17211fe', 'a', 'a', 'c5e3363cf27f707231c460dc37bb2afe', null, null, null, null, null, '2022-03-03 17:34:59', null, '2');
COMMIT;

-- ----------------------------
-- Auto increment value for `img`
-- ----------------------------
ALTER TABLE `img` AUTO_INCREMENT=30;
